<html>
<head>
<title>File Source for Serialized.php</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">PHPExcel_Reader</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
  		  [ <a href="../classtrees_PHPExcel_Reader.html" class="menu">class tree: PHPExcel_Reader</a> ]
		  [ <a href="../elementindex_PHPExcel_Reader.html" class="menu">index: PHPExcel_Reader</a> ]
		  [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
      <b>Packages:</b><br />
              <a href="../li_PHPExcel.html">PHPExcel</a><br />
              <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
              <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
              <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
              <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
              <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
              <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
              <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
              <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
            <br /><br />
                  
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1 align="center">Source for file Serialized.php</h1>
<p>Documentation is available at <a href="../PHPExcel_Reader/_Classes_PHPExcel_Reader_Serialized_php.html">Serialized.php</a></p>
<div class="php">
<div class="listing"><pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><span class="src-doc">/**</span></li>
<li><a name="a3"></a><span class="src-doc"> * PHPExcel</span></li>
<li><a name="a4"></a><span class="src-doc"> *</span></li>
<li><a name="a5"></a><span class="src-doc"> * Copyright (c) 2006 - 2007 PHPExcel, Maarten Balliauw</span></li>
<li><a name="a6"></a><span class="src-doc"> *</span></li>
<li><a name="a7"></a><span class="src-doc"> * This library is free software; you can redistribute it and/or</span></li>
<li><a name="a8"></a><span class="src-doc"> * modify it under the terms of the GNU Lesser General Public</span></li>
<li><a name="a9"></a><span class="src-doc"> * License as published by the Free Software Foundation; either</span></li>
<li><a name="a10"></a><span class="src-doc"> * version 2.1 of the License, or (at your option) any later version.</span></li>
<li><a name="a11"></a><span class="src-doc"> * </span></li>
<li><a name="a12"></a><span class="src-doc"> * This library is distributed in the hope that it will be useful,</span></li>
<li><a name="a13"></a><span class="src-doc"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span></li>
<li><a name="a14"></a><span class="src-doc"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU</span></li>
<li><a name="a15"></a><span class="src-doc"> * Lesser General Public License for more details.</span></li>
<li><a name="a16"></a><span class="src-doc"> * </span></li>
<li><a name="a17"></a><span class="src-doc"> * You should have received a copy of the GNU Lesser General Public</span></li>
<li><a name="a18"></a><span class="src-doc"> * License along with this library; if not, write to the Free Software</span></li>
<li><a name="a19"></a><span class="src-doc"> * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA</span></li>
<li><a name="a20"></a><span class="src-doc"> *</span></li>
<li><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a22"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Reader</span></li>
<li><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc">    http://www.gnu.org/licenses/lgpl.txt    LGPL</span></li>
<li><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc">    ##VERSION##, ##DATE##</span></li>
<li><a name="a26"></a><span class="src-doc"> */</span></li>
<li><a name="a27"></a>&nbsp;</li>
<li><a name="a28"></a>&nbsp;</li>
<li><a name="a29"></a><span class="src-doc">/** PHPExcel */</span></li>
<li><a name="a29"></a>&nbsp;</li>
<li><a name="a30"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel.php'</span><span class="src-sym">;</span></li>
<li><a name="a31"></a>&nbsp;</li>
<li><a name="a32"></a><span class="src-doc">/** PHPExcel_Reader_IReader */</span></li>
<li><a name="a32"></a>&nbsp;</li>
<li><a name="a33"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Reader/IReader.php'</span><span class="src-sym">;</span></li>
<li><a name="a34"></a>&nbsp;</li>
<li><a name="a35"></a><span class="src-doc">/** PHPExcel_Shared_File */</span></li>
<li><a name="a35"></a>&nbsp;</li>
<li><a name="a36"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Shared/File.php'</span><span class="src-sym">;</span></li>
<li><a name="a37"></a>&nbsp;</li>
<li><a name="a38"></a>&nbsp;</li>
<li><a name="a39"></a><span class="src-doc">/**</span></li>
<li><a name="a40"></a><span class="src-doc"> * PHPExcel_Reader_Serialized</span></li>
<li><a name="a41"></a><span class="src-doc"> *</span></li>
<li><a name="a42"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a43"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Reader</span></li>
<li><a name="a44"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a45"></a><span class="src-doc"> */</span></li>
<li><a name="a46"></a><span class="src-key">class </span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html">PHPExcel_Reader_Serialized</a> <span class="src-key">implements </span><span class="src-id">PHPExcel_Reader_IReader</span></li>
<li><a name="a47"></a><span class="src-sym">{</span></li>
<li><a name="a48"></a>    <span class="src-doc">/**</span></li>
<li><a name="a49"></a><span class="src-doc">     * Loads PHPExcel Serialized file</span></li>
<li><a name="a50"></a><span class="src-doc">     *</span></li>
<li><a name="a51"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">        </span><span class="src-doc-var">$pFilename </span></li>
<li><a name="a52"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span></li>
<li><a name="a53"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a54"></a><span class="src-doc">     */    </span></li>
<li><a name="a55"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html#methodload">load</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">)</span></li>
<li><a name="a56"></a>    <span class="src-sym">{</span></li>
<li><a name="a57"></a>        <span class="src-comm">// Check if file exists</span></li>
<li><a name="a58"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/file_exists">file_exists</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a59"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Could not open &quot; </span>. <span class="src-var">$pFilename </span>. <span class="src-str">&quot; for reading! File does not exist.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a60"></a>        <span class="src-sym">}</span></li>
<li><a name="a61"></a>&nbsp;</li>
<li><a name="a62"></a>        <span class="src-comm">// Unserialize... First make sure the file supports it!</span></li>
<li><a name="a63"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html#methodfileSupportsUnserializePHPExcel">fileSupportsUnserializePHPExcel</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a64"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid file format for PHPExcel_Reader_Serialized: &quot; </span>. <span class="src-var">$pFilename </span>. <span class="src-str">&quot;.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a65"></a>        <span class="src-sym">}</span></li>
<li><a name="a66"></a>            </li>
<li><a name="a67"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html#method_loadSerialized">_loadSerialized</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>    <span class="src-sym">}</span></li>
<li><a name="a69"></a>    </li>
<li><a name="a70"></a>    <span class="src-doc">/**</span></li>
<li><a name="a71"></a><span class="src-doc">     * Load PHPExcel Serialized file</span></li>
<li><a name="a72"></a><span class="src-doc">     *</span></li>
<li><a name="a73"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">        </span><span class="src-doc-var">$pFilename </span></li>
<li><a name="a74"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span></li>
<li><a name="a75"></a><span class="src-doc">     */</span></li>
<li><a name="a76"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html#method_loadSerialized">_loadSerialized</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a77"></a>        <span class="src-var">$xmlData </span>= <a href="http://www.php.net/simplexml_load_string">simplexml_load_string</a><span class="src-sym">(</span><a href="http://www.php.net/file_get_contents">file_get_contents</a><span class="src-sym">(</span><span class="src-str">&quot;</span><span class="src-str"><span class="src-id">zip</span>://<span class="src-var">$pFilename</span>#<span class="src-id">phpexcel</span>.<span class="src-id">xml</span></span><span class="src-str">&quot;</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a78"></a>        <span class="src-var">$excel </span>= <a href="http://www.php.net/unserialize">unserialize</a><span class="src-sym">(</span><a href="http://www.php.net/base64_decode">base64_decode</a><span class="src-sym">(</span>(string)<span class="src-var">$xmlData</span><span class="src-sym">-&gt;</span><span class="src-id">data</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>        </li>
<li><a name="a80"></a>        <span class="src-comm">// Update media links</span></li>
<li><a name="a81"></a>        <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$i </span>= <span class="src-num">0</span><span class="src-sym">; </span><span class="src-var">$i </span>&lt; <span class="src-var">$excel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheetCount</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">; </span><span class="src-var">$i</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a82"></a>            <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$j </span>= <span class="src-num">0</span><span class="src-sym">; </span><span class="src-var">$j </span>&lt; <span class="src-var">$excel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getDrawingCollection</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">count</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">; </span><span class="src-var">$j</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a83"></a>                <span class="src-var">$imgTemp </span>=<span class="src-sym">&amp; </span><span class="src-var">$excel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getDrawingCollection</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">offsetGet</span><span class="src-sym">(</span><span class="src-var">$j</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a84"></a>                <span class="src-var">$imgTemp</span><span class="src-sym">-&gt;</span><span class="src-id">setPath</span><span class="src-sym">(</span><span class="src-str">'zip://' </span>. <span class="src-var">$pFilename </span>. <span class="src-str">'#media/' </span>. <span class="src-var">$imgTemp</span><span class="src-sym">-&gt;</span><span class="src-id">getFilename</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-id">false</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a85"></a>            <span class="src-sym">}</span></li>
<li><a name="a86"></a>        <span class="src-sym">}</span></li>
<li><a name="a87"></a>&nbsp;</li>
<li><a name="a88"></a>        <span class="src-key">return </span><span class="src-var">$excel</span><span class="src-sym">;</span></li>
<li><a name="a89"></a>    <span class="src-sym">}</span></li>
<li><a name="a90"></a>    </li>
<li><a name="a91"></a>    <span class="src-doc">/**</span></li>
<li><a name="a92"></a><span class="src-doc">     * Does a file support UnserializePHPExcel ?</span></li>
<li><a name="a93"></a><span class="src-doc">     *</span></li>
<li><a name="a94"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">        </span><span class="src-doc-var">$pFilename </span></li>
<li><a name="a95"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a96"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">boolean </span></li>
<li><a name="a97"></a><span class="src-doc">     */</span></li>
<li><a name="a98"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel_Reader/PHPExcel_Reader_Serialized.html#methodfileSupportsUnserializePHPExcel">fileSupportsUnserializePHPExcel</a><span class="src-sym">(</span><span class="src-var">$pFilename </span>= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a99"></a>        <span class="src-comm">// Check if file exists</span></li>
<li><a name="a100"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/file_exists">file_exists</a><span class="src-sym">(</span><span class="src-var">$pFilename</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a101"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Could not open &quot; </span>. <span class="src-var">$pFilename </span>. <span class="src-str">&quot; for reading! File does not exist.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a102"></a>        <span class="src-sym">}</span></li>
<li><a name="a103"></a>        </li>
<li><a name="a104"></a>        <span class="src-comm">// File exists, does it contain phpexcel.xml?</span></li>
<li><a name="a105"></a>        <span class="src-key">return </span><span class="src-id"><a href="../PHPExcel_Shared/PHPExcel_Shared_File.html">PHPExcel_Shared_File</a></span><span class="src-sym">::</span><a href="../PHPExcel_Shared/PHPExcel_Shared_File.html#methodfile_exists">file_exists</a><span class="src-sym">(</span><span class="src-str">&quot;</span><span class="src-str"><span class="src-id">zip</span>://<span class="src-var">$pFilename</span>#<span class="src-id">phpexcel</span>.<span class="src-id">xml</span></span><span class="src-str">&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a106"></a>    <span class="src-sym">}</span></li>
<li><a name="a107"></a><span class="src-sym">}</span></li>
</ol></pre></div>
</div>
        <div class="credit">
		    <hr />
		    Documentation generated on Mon, 23 Apr 2007 12:55:40 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>